{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Help on function to_excel in module pandas.core.frame:\n",
      "\n",
      "to_excel(self, excel_writer, sheet_name='Sheet1', na_rep='', float_format=None, columns=None, header=True, index=True, index_label=None, startrow=0, startcol=0, engine=None, merge_cells=True, encoding=None, inf_rep='inf', verbose=True, freeze_panes=None)\n",
      "    Write DataFrame to an excel sheet\n",
      "    \n",
      "    \n",
      "    Parameters\n",
      "    ----------\n",
      "    excel_writer : string or ExcelWriter object\n",
      "        File path or existing ExcelWriter\n",
      "    sheet_name : string, default 'Sheet1'\n",
      "        Name of sheet which will contain DataFrame\n",
      "    na_rep : string, default ''\n",
      "        Missing data representation\n",
      "    float_format : string, default None\n",
      "        Format string for floating point numbers\n",
      "    columns : sequence, optional\n",
      "        Columns to write\n",
      "    header : boolean or list of string, default True\n",
      "        Write out the column names. If a list of strings is given it is\n",
      "        assumed to be aliases for the column names\n",
      "    index : boolean, default True\n",
      "        Write row names (index)\n",
      "    index_label : string or sequence, default None\n",
      "        Column label for index column(s) if desired. If None is given, and\n",
      "        `header` and `index` are True, then the index names are used. A\n",
      "        sequence should be given if the DataFrame uses MultiIndex.\n",
      "    startrow :\n",
      "        upper left cell row to dump data frame\n",
      "    startcol :\n",
      "        upper left cell column to dump data frame\n",
      "    engine : string, default None\n",
      "        write engine to use - you can also set this via the options\n",
      "        ``io.excel.xlsx.writer``, ``io.excel.xls.writer``, and\n",
      "        ``io.excel.xlsm.writer``.\n",
      "    merge_cells : boolean, default True\n",
      "        Write MultiIndex and Hierarchical Rows as merged cells.\n",
      "    encoding: string, default None\n",
      "        encoding of the resulting excel file. Only necessary for xlwt,\n",
      "        other writers support unicode natively.\n",
      "    inf_rep : string, default 'inf'\n",
      "        Representation for infinity (there is no native representation for\n",
      "        infinity in Excel)\n",
      "    freeze_panes : tuple of integer (length 2), default None\n",
      "        Specifies the one-based bottommost row and rightmost column that\n",
      "        is to be frozen\n",
      "    \n",
      "        .. versionadded:: 0.20.0\n",
      "    \n",
      "    Notes\n",
      "    -----\n",
      "    If passing an existing ExcelWriter object, then the sheet will be added\n",
      "    to the existing workbook.  This can be used to save different\n",
      "    DataFrames to one workbook:\n",
      "    \n",
      "    >>> writer = pd.ExcelWriter('output.xlsx')\n",
      "    >>> df1.to_excel(writer,'Sheet1')\n",
      "    >>> df2.to_excel(writer,'Sheet2')\n",
      "    >>> writer.save()\n",
      "    \n",
      "    For compatibility with to_csv, to_excel serializes lists and dicts to\n",
      "    strings before writing.\n",
      "\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "help(pd.DataFrame.to_excel)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>open</th>\n",
       "      <th>high</th>\n",
       "      <th>close</th>\n",
       "      <th>low</th>\n",
       "      <th>volume</th>\n",
       "      <th>price_change</th>\n",
       "      <th>p_change</th>\n",
       "      <th>ma5</th>\n",
       "      <th>ma10</th>\n",
       "      <th>ma20</th>\n",
       "      <th>v_ma5</th>\n",
       "      <th>v_ma10</th>\n",
       "      <th>v_ma20</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2019-07-19</th>\n",
       "      <td>3.04</td>\n",
       "      <td>3.06</td>\n",
       "      <td>3.05</td>\n",
       "      <td>3.03</td>\n",
       "      <td>60364.91</td>\n",
       "      <td>0.03</td>\n",
       "      <td>0.99</td>\n",
       "      <td>3.054</td>\n",
       "      <td>3.054</td>\n",
       "      <td>3.100</td>\n",
       "      <td>73657.55</td>\n",
       "      <td>105869.71</td>\n",
       "      <td>140267.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-07-18</th>\n",
       "      <td>3.05</td>\n",
       "      <td>3.05</td>\n",
       "      <td>3.02</td>\n",
       "      <td>3.02</td>\n",
       "      <td>70460.00</td>\n",
       "      <td>-0.04</td>\n",
       "      <td>-1.31</td>\n",
       "      <td>3.058</td>\n",
       "      <td>3.063</td>\n",
       "      <td>3.106</td>\n",
       "      <td>84601.99</td>\n",
       "      <td>106993.41</td>\n",
       "      <td>149133.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-07-17</th>\n",
       "      <td>3.04</td>\n",
       "      <td>3.07</td>\n",
       "      <td>3.06</td>\n",
       "      <td>3.04</td>\n",
       "      <td>64222.01</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3.074</td>\n",
       "      <td>3.074</td>\n",
       "      <td>3.113</td>\n",
       "      <td>123095.80</td>\n",
       "      <td>109450.36</td>\n",
       "      <td>156408.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-07-16</th>\n",
       "      <td>3.08</td>\n",
       "      <td>3.08</td>\n",
       "      <td>3.06</td>\n",
       "      <td>3.04</td>\n",
       "      <td>73356.18</td>\n",
       "      <td>-0.02</td>\n",
       "      <td>-0.65</td>\n",
       "      <td>3.064</td>\n",
       "      <td>3.081</td>\n",
       "      <td>3.115</td>\n",
       "      <td>123157.78</td>\n",
       "      <td>115757.67</td>\n",
       "      <td>161567.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-07-15</th>\n",
       "      <td>3.07</td>\n",
       "      <td>3.09</td>\n",
       "      <td>3.08</td>\n",
       "      <td>3.00</td>\n",
       "      <td>99884.64</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.33</td>\n",
       "      <td>3.060</td>\n",
       "      <td>3.092</td>\n",
       "      <td>3.117</td>\n",
       "      <td>126037.72</td>\n",
       "      <td>124907.26</td>\n",
       "      <td>167210.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-07-12</th>\n",
       "      <td>3.07</td>\n",
       "      <td>3.09</td>\n",
       "      <td>3.07</td>\n",
       "      <td>3.05</td>\n",
       "      <td>115087.14</td>\n",
       "      <td>-0.03</td>\n",
       "      <td>-0.97</td>\n",
       "      <td>3.054</td>\n",
       "      <td>3.106</td>\n",
       "      <td>3.115</td>\n",
       "      <td>138081.86</td>\n",
       "      <td>148553.59</td>\n",
       "      <td>168306.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-07-11</th>\n",
       "      <td>3.00</td>\n",
       "      <td>3.20</td>\n",
       "      <td>3.10</td>\n",
       "      <td>3.00</td>\n",
       "      <td>262929.03</td>\n",
       "      <td>0.09</td>\n",
       "      <td>2.99</td>\n",
       "      <td>3.068</td>\n",
       "      <td>3.117</td>\n",
       "      <td>3.116</td>\n",
       "      <td>129384.83</td>\n",
       "      <td>186458.85</td>\n",
       "      <td>178697.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-07-10</th>\n",
       "      <td>3.04</td>\n",
       "      <td>3.06</td>\n",
       "      <td>3.01</td>\n",
       "      <td>3.00</td>\n",
       "      <td>64531.89</td>\n",
       "      <td>-0.03</td>\n",
       "      <td>-0.99</td>\n",
       "      <td>3.074</td>\n",
       "      <td>3.120</td>\n",
       "      <td>3.115</td>\n",
       "      <td>95804.92</td>\n",
       "      <td>171442.57</td>\n",
       "      <td>176124.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-07-09</th>\n",
       "      <td>3.05</td>\n",
       "      <td>3.06</td>\n",
       "      <td>3.04</td>\n",
       "      <td>3.01</td>\n",
       "      <td>87755.88</td>\n",
       "      <td>-0.01</td>\n",
       "      <td>-0.33</td>\n",
       "      <td>3.098</td>\n",
       "      <td>3.129</td>\n",
       "      <td>3.116</td>\n",
       "      <td>108357.56</td>\n",
       "      <td>174784.47</td>\n",
       "      <td>182362.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-07-08</th>\n",
       "      <td>3.14</td>\n",
       "      <td>3.14</td>\n",
       "      <td>3.05</td>\n",
       "      <td>3.03</td>\n",
       "      <td>160105.38</td>\n",
       "      <td>-0.09</td>\n",
       "      <td>-2.87</td>\n",
       "      <td>3.124</td>\n",
       "      <td>3.136</td>\n",
       "      <td>3.115</td>\n",
       "      <td>123776.80</td>\n",
       "      <td>179452.28</td>\n",
       "      <td>187995.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-07-05</th>\n",
       "      <td>3.15</td>\n",
       "      <td>3.15</td>\n",
       "      <td>3.14</td>\n",
       "      <td>3.11</td>\n",
       "      <td>71601.97</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.32</td>\n",
       "      <td>3.158</td>\n",
       "      <td>3.146</td>\n",
       "      <td>3.109</td>\n",
       "      <td>159025.31</td>\n",
       "      <td>174666.01</td>\n",
       "      <td>185150.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-07-04</th>\n",
       "      <td>3.13</td>\n",
       "      <td>3.15</td>\n",
       "      <td>3.13</td>\n",
       "      <td>3.11</td>\n",
       "      <td>95029.46</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3.166</td>\n",
       "      <td>3.148</td>\n",
       "      <td>3.098</td>\n",
       "      <td>243532.86</td>\n",
       "      <td>191274.02</td>\n",
       "      <td>187217.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-07-03</th>\n",
       "      <td>3.16</td>\n",
       "      <td>3.17</td>\n",
       "      <td>3.13</td>\n",
       "      <td>3.12</td>\n",
       "      <td>127295.10</td>\n",
       "      <td>-0.04</td>\n",
       "      <td>-1.26</td>\n",
       "      <td>3.166</td>\n",
       "      <td>3.151</td>\n",
       "      <td>3.090</td>\n",
       "      <td>247080.22</td>\n",
       "      <td>203366.56</td>\n",
       "      <td>187531.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-07-02</th>\n",
       "      <td>3.20</td>\n",
       "      <td>3.21</td>\n",
       "      <td>3.17</td>\n",
       "      <td>3.17</td>\n",
       "      <td>164852.09</td>\n",
       "      <td>-0.05</td>\n",
       "      <td>-1.55</td>\n",
       "      <td>3.160</td>\n",
       "      <td>3.149</td>\n",
       "      <td>3.081</td>\n",
       "      <td>241211.37</td>\n",
       "      <td>207376.75</td>\n",
       "      <td>187385.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-07-01</th>\n",
       "      <td>3.22</td>\n",
       "      <td>3.22</td>\n",
       "      <td>3.22</td>\n",
       "      <td>3.17</td>\n",
       "      <td>336347.91</td>\n",
       "      <td>0.04</td>\n",
       "      <td>1.26</td>\n",
       "      <td>3.148</td>\n",
       "      <td>3.141</td>\n",
       "      <td>3.072</td>\n",
       "      <td>235127.75</td>\n",
       "      <td>209514.04</td>\n",
       "      <td>185622.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-06-28</th>\n",
       "      <td>3.20</td>\n",
       "      <td>3.30</td>\n",
       "      <td>3.18</td>\n",
       "      <td>3.17</td>\n",
       "      <td>494139.75</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1.60</td>\n",
       "      <td>3.134</td>\n",
       "      <td>3.124</td>\n",
       "      <td>3.062</td>\n",
       "      <td>190306.72</td>\n",
       "      <td>188058.85</td>\n",
       "      <td>176716.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-06-27</th>\n",
       "      <td>3.13</td>\n",
       "      <td>3.15</td>\n",
       "      <td>3.13</td>\n",
       "      <td>3.10</td>\n",
       "      <td>112766.25</td>\n",
       "      <td>0.03</td>\n",
       "      <td>0.97</td>\n",
       "      <td>3.130</td>\n",
       "      <td>3.114</td>\n",
       "      <td>3.055</td>\n",
       "      <td>139015.17</td>\n",
       "      <td>170935.57</td>\n",
       "      <td>161966.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-06-26</th>\n",
       "      <td>3.12</td>\n",
       "      <td>3.14</td>\n",
       "      <td>3.10</td>\n",
       "      <td>3.09</td>\n",
       "      <td>97950.86</td>\n",
       "      <td>-0.01</td>\n",
       "      <td>-0.32</td>\n",
       "      <td>3.136</td>\n",
       "      <td>3.110</td>\n",
       "      <td>3.050</td>\n",
       "      <td>159652.89</td>\n",
       "      <td>180805.73</td>\n",
       "      <td>162603.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-06-25</th>\n",
       "      <td>3.14</td>\n",
       "      <td>3.16</td>\n",
       "      <td>3.11</td>\n",
       "      <td>3.08</td>\n",
       "      <td>134434.00</td>\n",
       "      <td>-0.04</td>\n",
       "      <td>-1.27</td>\n",
       "      <td>3.138</td>\n",
       "      <td>3.103</td>\n",
       "      <td>3.046</td>\n",
       "      <td>173542.12</td>\n",
       "      <td>189940.75</td>\n",
       "      <td>166029.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-06-24</th>\n",
       "      <td>3.15</td>\n",
       "      <td>3.17</td>\n",
       "      <td>3.15</td>\n",
       "      <td>3.13</td>\n",
       "      <td>112242.75</td>\n",
       "      <td>-0.01</td>\n",
       "      <td>-0.32</td>\n",
       "      <td>3.134</td>\n",
       "      <td>3.094</td>\n",
       "      <td>3.042</td>\n",
       "      <td>183900.32</td>\n",
       "      <td>196539.12</td>\n",
       "      <td>168569.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-06-21</th>\n",
       "      <td>3.16</td>\n",
       "      <td>3.19</td>\n",
       "      <td>3.16</td>\n",
       "      <td>3.14</td>\n",
       "      <td>237682.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3.114</td>\n",
       "      <td>3.072</td>\n",
       "      <td>3.034</td>\n",
       "      <td>185810.97</td>\n",
       "      <td>195635.12</td>\n",
       "      <td>173677.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-06-20</th>\n",
       "      <td>3.10</td>\n",
       "      <td>3.17</td>\n",
       "      <td>3.16</td>\n",
       "      <td>3.07</td>\n",
       "      <td>215954.84</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1.61</td>\n",
       "      <td>3.098</td>\n",
       "      <td>3.047</td>\n",
       "      <td>3.027</td>\n",
       "      <td>202855.97</td>\n",
       "      <td>183161.31</td>\n",
       "      <td>172395.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-06-19</th>\n",
       "      <td>3.14</td>\n",
       "      <td>3.16</td>\n",
       "      <td>3.11</td>\n",
       "      <td>3.10</td>\n",
       "      <td>167397.00</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.65</td>\n",
       "      <td>3.084</td>\n",
       "      <td>3.028</td>\n",
       "      <td>3.023</td>\n",
       "      <td>201958.58</td>\n",
       "      <td>171695.81</td>\n",
       "      <td>171053.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-06-18</th>\n",
       "      <td>3.15</td>\n",
       "      <td>3.20</td>\n",
       "      <td>3.09</td>\n",
       "      <td>3.08</td>\n",
       "      <td>186225.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>1.31</td>\n",
       "      <td>3.068</td>\n",
       "      <td>3.012</td>\n",
       "      <td>3.023</td>\n",
       "      <td>206339.38</td>\n",
       "      <td>167394.03</td>\n",
       "      <td>172025.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-06-17</th>\n",
       "      <td>3.05</td>\n",
       "      <td>3.09</td>\n",
       "      <td>3.05</td>\n",
       "      <td>3.03</td>\n",
       "      <td>121796.00</td>\n",
       "      <td>-0.03</td>\n",
       "      <td>-0.97</td>\n",
       "      <td>3.054</td>\n",
       "      <td>3.002</td>\n",
       "      <td>3.023</td>\n",
       "      <td>209177.93</td>\n",
       "      <td>161730.43</td>\n",
       "      <td>174063.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-06-14</th>\n",
       "      <td>3.19</td>\n",
       "      <td>3.25</td>\n",
       "      <td>3.08</td>\n",
       "      <td>3.08</td>\n",
       "      <td>322907.00</td>\n",
       "      <td>-0.01</td>\n",
       "      <td>-0.32</td>\n",
       "      <td>3.030</td>\n",
       "      <td>3.000</td>\n",
       "      <td>3.027</td>\n",
       "      <td>205459.28</td>\n",
       "      <td>165375.01</td>\n",
       "      <td>183704.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-06-13</th>\n",
       "      <td>3.04</td>\n",
       "      <td>3.09</td>\n",
       "      <td>3.09</td>\n",
       "      <td>3.02</td>\n",
       "      <td>211467.88</td>\n",
       "      <td>0.06</td>\n",
       "      <td>1.98</td>\n",
       "      <td>2.996</td>\n",
       "      <td>2.996</td>\n",
       "      <td>3.036</td>\n",
       "      <td>163466.66</td>\n",
       "      <td>152996.69</td>\n",
       "      <td>180431.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-06-12</th>\n",
       "      <td>3.02</td>\n",
       "      <td>3.09</td>\n",
       "      <td>3.03</td>\n",
       "      <td>3.01</td>\n",
       "      <td>189301.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.33</td>\n",
       "      <td>2.972</td>\n",
       "      <td>2.990</td>\n",
       "      <td>3.045</td>\n",
       "      <td>141433.04</td>\n",
       "      <td>144401.39</td>\n",
       "      <td>192434.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-06-11</th>\n",
       "      <td>2.93</td>\n",
       "      <td>3.03</td>\n",
       "      <td>3.02</td>\n",
       "      <td>2.92</td>\n",
       "      <td>200417.77</td>\n",
       "      <td>0.09</td>\n",
       "      <td>3.07</td>\n",
       "      <td>2.956</td>\n",
       "      <td>2.989</td>\n",
       "      <td>3.055</td>\n",
       "      <td>128448.67</td>\n",
       "      <td>142118.48</td>\n",
       "      <td>202484.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-06-10</th>\n",
       "      <td>2.91</td>\n",
       "      <td>2.95</td>\n",
       "      <td>2.93</td>\n",
       "      <td>2.90</td>\n",
       "      <td>103202.75</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.69</td>\n",
       "      <td>2.950</td>\n",
       "      <td>2.990</td>\n",
       "      <td>3.063</td>\n",
       "      <td>114282.93</td>\n",
       "      <td>140600.46</td>\n",
       "      <td>203010.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-07</th>\n",
       "      <td>6.17</td>\n",
       "      <td>6.18</td>\n",
       "      <td>6.16</td>\n",
       "      <td>6.12</td>\n",
       "      <td>88789.01</td>\n",
       "      <td>-0.01</td>\n",
       "      <td>-0.16</td>\n",
       "      <td>6.148</td>\n",
       "      <td>6.200</td>\n",
       "      <td>6.226</td>\n",
       "      <td>125309.90</td>\n",
       "      <td>140545.92</td>\n",
       "      <td>169896.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-06</th>\n",
       "      <td>6.12</td>\n",
       "      <td>6.18</td>\n",
       "      <td>6.17</td>\n",
       "      <td>6.10</td>\n",
       "      <td>107700.99</td>\n",
       "      <td>0.07</td>\n",
       "      <td>1.15</td>\n",
       "      <td>6.154</td>\n",
       "      <td>6.214</td>\n",
       "      <td>6.227</td>\n",
       "      <td>134116.82</td>\n",
       "      <td>150005.82</td>\n",
       "      <td>170855.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-03</th>\n",
       "      <td>6.11</td>\n",
       "      <td>6.13</td>\n",
       "      <td>6.10</td>\n",
       "      <td>6.05</td>\n",
       "      <td>167476.27</td>\n",
       "      <td>-0.03</td>\n",
       "      <td>-0.49</td>\n",
       "      <td>6.158</td>\n",
       "      <td>6.224</td>\n",
       "      <td>6.226</td>\n",
       "      <td>147953.52</td>\n",
       "      <td>157405.10</td>\n",
       "      <td>170791.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-02</th>\n",
       "      <td>6.18</td>\n",
       "      <td>6.21</td>\n",
       "      <td>6.13</td>\n",
       "      <td>6.12</td>\n",
       "      <td>130263.30</td>\n",
       "      <td>-0.05</td>\n",
       "      <td>-0.81</td>\n",
       "      <td>6.194</td>\n",
       "      <td>6.236</td>\n",
       "      <td>6.226</td>\n",
       "      <td>137315.14</td>\n",
       "      <td>159817.62</td>\n",
       "      <td>165596.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-01</th>\n",
       "      <td>6.21</td>\n",
       "      <td>6.21</td>\n",
       "      <td>6.18</td>\n",
       "      <td>6.17</td>\n",
       "      <td>132319.91</td>\n",
       "      <td>-0.01</td>\n",
       "      <td>-0.16</td>\n",
       "      <td>6.222</td>\n",
       "      <td>6.251</td>\n",
       "      <td>6.224</td>\n",
       "      <td>141737.49</td>\n",
       "      <td>170822.37</td>\n",
       "      <td>165060.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-28</th>\n",
       "      <td>6.20</td>\n",
       "      <td>6.22</td>\n",
       "      <td>6.19</td>\n",
       "      <td>6.14</td>\n",
       "      <td>132823.61</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>6.252</td>\n",
       "      <td>6.261</td>\n",
       "      <td>6.220</td>\n",
       "      <td>155781.95</td>\n",
       "      <td>201817.79</td>\n",
       "      <td>163236.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-27</th>\n",
       "      <td>6.29</td>\n",
       "      <td>6.33</td>\n",
       "      <td>6.19</td>\n",
       "      <td>6.17</td>\n",
       "      <td>176884.50</td>\n",
       "      <td>-0.09</td>\n",
       "      <td>-1.43</td>\n",
       "      <td>6.274</td>\n",
       "      <td>6.263</td>\n",
       "      <td>6.217</td>\n",
       "      <td>165894.83</td>\n",
       "      <td>206214.59</td>\n",
       "      <td>160353.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-24</th>\n",
       "      <td>6.27</td>\n",
       "      <td>6.29</td>\n",
       "      <td>6.28</td>\n",
       "      <td>6.23</td>\n",
       "      <td>114284.40</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.16</td>\n",
       "      <td>6.290</td>\n",
       "      <td>6.269</td>\n",
       "      <td>6.215</td>\n",
       "      <td>166856.67</td>\n",
       "      <td>202553.82</td>\n",
       "      <td>157042.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-23</th>\n",
       "      <td>6.33</td>\n",
       "      <td>6.33</td>\n",
       "      <td>6.27</td>\n",
       "      <td>6.24</td>\n",
       "      <td>152375.03</td>\n",
       "      <td>-0.06</td>\n",
       "      <td>-0.95</td>\n",
       "      <td>6.278</td>\n",
       "      <td>6.267</td>\n",
       "      <td>6.207</td>\n",
       "      <td>182320.10</td>\n",
       "      <td>207932.94</td>\n",
       "      <td>156508.68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-22</th>\n",
       "      <td>6.31</td>\n",
       "      <td>6.39</td>\n",
       "      <td>6.33</td>\n",
       "      <td>6.29</td>\n",
       "      <td>202542.20</td>\n",
       "      <td>0.03</td>\n",
       "      <td>0.48</td>\n",
       "      <td>6.280</td>\n",
       "      <td>6.262</td>\n",
       "      <td>6.196</td>\n",
       "      <td>199907.24</td>\n",
       "      <td>205858.66</td>\n",
       "      <td>154501.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-21</th>\n",
       "      <td>6.26</td>\n",
       "      <td>6.30</td>\n",
       "      <td>6.30</td>\n",
       "      <td>6.25</td>\n",
       "      <td>183388.00</td>\n",
       "      <td>0.03</td>\n",
       "      <td>0.48</td>\n",
       "      <td>6.270</td>\n",
       "      <td>6.252</td>\n",
       "      <td>6.186</td>\n",
       "      <td>247853.62</td>\n",
       "      <td>199247.17</td>\n",
       "      <td>149792.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-20</th>\n",
       "      <td>6.20</td>\n",
       "      <td>6.27</td>\n",
       "      <td>6.27</td>\n",
       "      <td>6.19</td>\n",
       "      <td>181693.73</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.80</td>\n",
       "      <td>6.252</td>\n",
       "      <td>6.239</td>\n",
       "      <td>6.180</td>\n",
       "      <td>246534.36</td>\n",
       "      <td>191705.12</td>\n",
       "      <td>148024.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-17</th>\n",
       "      <td>6.27</td>\n",
       "      <td>6.32</td>\n",
       "      <td>6.22</td>\n",
       "      <td>6.21</td>\n",
       "      <td>191601.52</td>\n",
       "      <td>-0.06</td>\n",
       "      <td>-0.95</td>\n",
       "      <td>6.248</td>\n",
       "      <td>6.227</td>\n",
       "      <td>6.175</td>\n",
       "      <td>238250.97</td>\n",
       "      <td>184178.20</td>\n",
       "      <td>146153.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16</th>\n",
       "      <td>6.24</td>\n",
       "      <td>6.30</td>\n",
       "      <td>6.28</td>\n",
       "      <td>6.19</td>\n",
       "      <td>240310.77</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>6.256</td>\n",
       "      <td>6.215</td>\n",
       "      <td>6.172</td>\n",
       "      <td>233545.79</td>\n",
       "      <td>171376.32</td>\n",
       "      <td>143480.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-15</th>\n",
       "      <td>6.22</td>\n",
       "      <td>6.50</td>\n",
       "      <td>6.28</td>\n",
       "      <td>6.16</td>\n",
       "      <td>442274.09</td>\n",
       "      <td>0.07</td>\n",
       "      <td>1.13</td>\n",
       "      <td>6.244</td>\n",
       "      <td>6.196</td>\n",
       "      <td>6.166</td>\n",
       "      <td>211810.07</td>\n",
       "      <td>159299.60</td>\n",
       "      <td>137428.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-14</th>\n",
       "      <td>6.25</td>\n",
       "      <td>6.27</td>\n",
       "      <td>6.21</td>\n",
       "      <td>6.18</td>\n",
       "      <td>176791.69</td>\n",
       "      <td>-0.04</td>\n",
       "      <td>-0.64</td>\n",
       "      <td>6.234</td>\n",
       "      <td>6.178</td>\n",
       "      <td>6.158</td>\n",
       "      <td>150640.73</td>\n",
       "      <td>124654.40</td>\n",
       "      <td>117105.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-13</th>\n",
       "      <td>6.23</td>\n",
       "      <td>6.25</td>\n",
       "      <td>6.25</td>\n",
       "      <td>6.20</td>\n",
       "      <td>140276.80</td>\n",
       "      <td>-0.01</td>\n",
       "      <td>-0.16</td>\n",
       "      <td>6.226</td>\n",
       "      <td>6.170</td>\n",
       "      <td>6.154</td>\n",
       "      <td>136875.88</td>\n",
       "      <td>114491.53</td>\n",
       "      <td>112842.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-10</th>\n",
       "      <td>6.21</td>\n",
       "      <td>6.26</td>\n",
       "      <td>6.26</td>\n",
       "      <td>6.21</td>\n",
       "      <td>168075.59</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.64</td>\n",
       "      <td>6.206</td>\n",
       "      <td>6.161</td>\n",
       "      <td>6.147</td>\n",
       "      <td>130105.43</td>\n",
       "      <td>111531.09</td>\n",
       "      <td>110731.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-09</th>\n",
       "      <td>6.21</td>\n",
       "      <td>6.23</td>\n",
       "      <td>6.22</td>\n",
       "      <td>6.19</td>\n",
       "      <td>131632.17</td>\n",
       "      <td>-0.01</td>\n",
       "      <td>-0.16</td>\n",
       "      <td>6.174</td>\n",
       "      <td>6.146</td>\n",
       "      <td>6.138</td>\n",
       "      <td>109206.84</td>\n",
       "      <td>105084.42</td>\n",
       "      <td>105952.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-08</th>\n",
       "      <td>6.15</td>\n",
       "      <td>6.24</td>\n",
       "      <td>6.23</td>\n",
       "      <td>6.15</td>\n",
       "      <td>136427.38</td>\n",
       "      <td>0.06</td>\n",
       "      <td>0.97</td>\n",
       "      <td>6.148</td>\n",
       "      <td>6.130</td>\n",
       "      <td>6.130</td>\n",
       "      <td>106789.14</td>\n",
       "      <td>103144.97</td>\n",
       "      <td>103618.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-07</th>\n",
       "      <td>6.14</td>\n",
       "      <td>6.19</td>\n",
       "      <td>6.17</td>\n",
       "      <td>6.12</td>\n",
       "      <td>107967.44</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.33</td>\n",
       "      <td>6.122</td>\n",
       "      <td>6.120</td>\n",
       "      <td>6.120</td>\n",
       "      <td>98668.08</td>\n",
       "      <td>100337.61</td>\n",
       "      <td>100337.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-06</th>\n",
       "      <td>6.10</td>\n",
       "      <td>6.15</td>\n",
       "      <td>6.15</td>\n",
       "      <td>6.07</td>\n",
       "      <td>106424.59</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.82</td>\n",
       "      <td>6.114</td>\n",
       "      <td>6.114</td>\n",
       "      <td>6.114</td>\n",
       "      <td>92107.19</td>\n",
       "      <td>99489.85</td>\n",
       "      <td>99489.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-03</th>\n",
       "      <td>6.09</td>\n",
       "      <td>6.12</td>\n",
       "      <td>6.10</td>\n",
       "      <td>6.07</td>\n",
       "      <td>63582.63</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.16</td>\n",
       "      <td>6.116</td>\n",
       "      <td>6.110</td>\n",
       "      <td>6.110</td>\n",
       "      <td>92956.74</td>\n",
       "      <td>98623.01</td>\n",
       "      <td>98623.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-26</th>\n",
       "      <td>6.08</td>\n",
       "      <td>6.11</td>\n",
       "      <td>6.09</td>\n",
       "      <td>6.05</td>\n",
       "      <td>119543.64</td>\n",
       "      <td>-0.01</td>\n",
       "      <td>-0.16</td>\n",
       "      <td>6.118</td>\n",
       "      <td>6.111</td>\n",
       "      <td>6.111</td>\n",
       "      <td>100961.99</td>\n",
       "      <td>103628.77</td>\n",
       "      <td>103628.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-25</th>\n",
       "      <td>6.12</td>\n",
       "      <td>6.15</td>\n",
       "      <td>6.10</td>\n",
       "      <td>6.09</td>\n",
       "      <td>95822.09</td>\n",
       "      <td>-0.03</td>\n",
       "      <td>-0.49</td>\n",
       "      <td>6.112</td>\n",
       "      <td>6.115</td>\n",
       "      <td>6.115</td>\n",
       "      <td>99500.81</td>\n",
       "      <td>100976.30</td>\n",
       "      <td>100976.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-24</th>\n",
       "      <td>6.17</td>\n",
       "      <td>6.19</td>\n",
       "      <td>6.13</td>\n",
       "      <td>6.13</td>\n",
       "      <td>75163.00</td>\n",
       "      <td>-0.03</td>\n",
       "      <td>-0.49</td>\n",
       "      <td>6.118</td>\n",
       "      <td>6.118</td>\n",
       "      <td>6.118</td>\n",
       "      <td>102007.14</td>\n",
       "      <td>102007.14</td>\n",
       "      <td>102007.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-23</th>\n",
       "      <td>6.10</td>\n",
       "      <td>6.19</td>\n",
       "      <td>6.16</td>\n",
       "      <td>6.09</td>\n",
       "      <td>110672.32</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.82</td>\n",
       "      <td>6.115</td>\n",
       "      <td>6.115</td>\n",
       "      <td>6.115</td>\n",
       "      <td>108718.17</td>\n",
       "      <td>108718.17</td>\n",
       "      <td>108718.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-20</th>\n",
       "      <td>6.06</td>\n",
       "      <td>6.13</td>\n",
       "      <td>6.11</td>\n",
       "      <td>6.02</td>\n",
       "      <td>103608.90</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.82</td>\n",
       "      <td>6.100</td>\n",
       "      <td>6.100</td>\n",
       "      <td>6.100</td>\n",
       "      <td>108066.79</td>\n",
       "      <td>108066.79</td>\n",
       "      <td>108066.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-19</th>\n",
       "      <td>6.09</td>\n",
       "      <td>6.11</td>\n",
       "      <td>6.06</td>\n",
       "      <td>5.99</td>\n",
       "      <td>112237.73</td>\n",
       "      <td>-0.07</td>\n",
       "      <td>-1.14</td>\n",
       "      <td>6.095</td>\n",
       "      <td>6.095</td>\n",
       "      <td>6.095</td>\n",
       "      <td>110295.74</td>\n",
       "      <td>110295.74</td>\n",
       "      <td>110295.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-18</th>\n",
       "      <td>6.16</td>\n",
       "      <td>6.18</td>\n",
       "      <td>6.13</td>\n",
       "      <td>6.10</td>\n",
       "      <td>108353.74</td>\n",
       "      <td>-0.04</td>\n",
       "      <td>-0.65</td>\n",
       "      <td>6.130</td>\n",
       "      <td>6.130</td>\n",
       "      <td>6.130</td>\n",
       "      <td>108353.74</td>\n",
       "      <td>108353.74</td>\n",
       "      <td>108353.74</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>609 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            open  high  close   low     volume  price_change  p_change    ma5  \\\n",
       "date                                                                            \n",
       "2019-07-19  3.04  3.06   3.05  3.03   60364.91          0.03      0.99  3.054   \n",
       "2019-07-18  3.05  3.05   3.02  3.02   70460.00         -0.04     -1.31  3.058   \n",
       "2019-07-17  3.04  3.07   3.06  3.04   64222.01          0.00      0.00  3.074   \n",
       "2019-07-16  3.08  3.08   3.06  3.04   73356.18         -0.02     -0.65  3.064   \n",
       "2019-07-15  3.07  3.09   3.08  3.00   99884.64          0.01      0.33  3.060   \n",
       "2019-07-12  3.07  3.09   3.07  3.05  115087.14         -0.03     -0.97  3.054   \n",
       "2019-07-11  3.00  3.20   3.10  3.00  262929.03          0.09      2.99  3.068   \n",
       "2019-07-10  3.04  3.06   3.01  3.00   64531.89         -0.03     -0.99  3.074   \n",
       "2019-07-09  3.05  3.06   3.04  3.01   87755.88         -0.01     -0.33  3.098   \n",
       "2019-07-08  3.14  3.14   3.05  3.03  160105.38         -0.09     -2.87  3.124   \n",
       "2019-07-05  3.15  3.15   3.14  3.11   71601.97          0.01      0.32  3.158   \n",
       "2019-07-04  3.13  3.15   3.13  3.11   95029.46          0.00      0.00  3.166   \n",
       "2019-07-03  3.16  3.17   3.13  3.12  127295.10         -0.04     -1.26  3.166   \n",
       "2019-07-02  3.20  3.21   3.17  3.17  164852.09         -0.05     -1.55  3.160   \n",
       "2019-07-01  3.22  3.22   3.22  3.17  336347.91          0.04      1.26  3.148   \n",
       "2019-06-28  3.20  3.30   3.18  3.17  494139.75          0.05      1.60  3.134   \n",
       "2019-06-27  3.13  3.15   3.13  3.10  112766.25          0.03      0.97  3.130   \n",
       "2019-06-26  3.12  3.14   3.10  3.09   97950.86         -0.01     -0.32  3.136   \n",
       "2019-06-25  3.14  3.16   3.11  3.08  134434.00         -0.04     -1.27  3.138   \n",
       "2019-06-24  3.15  3.17   3.15  3.13  112242.75         -0.01     -0.32  3.134   \n",
       "2019-06-21  3.16  3.19   3.16  3.14  237682.00          0.00      0.00  3.114   \n",
       "2019-06-20  3.10  3.17   3.16  3.07  215954.84          0.05      1.61  3.098   \n",
       "2019-06-19  3.14  3.16   3.11  3.10  167397.00          0.02      0.65  3.084   \n",
       "2019-06-18  3.15  3.20   3.09  3.08  186225.00          0.04      1.31  3.068   \n",
       "2019-06-17  3.05  3.09   3.05  3.03  121796.00         -0.03     -0.97  3.054   \n",
       "2019-06-14  3.19  3.25   3.08  3.08  322907.00         -0.01     -0.32  3.030   \n",
       "2019-06-13  3.04  3.09   3.09  3.02  211467.88          0.06      1.98  2.996   \n",
       "2019-06-12  3.02  3.09   3.03  3.01  189301.00          0.01      0.33  2.972   \n",
       "2019-06-11  2.93  3.03   3.02  2.92  200417.77          0.09      3.07  2.956   \n",
       "2019-06-10  2.91  2.95   2.93  2.90  103202.75          0.02      0.69  2.950   \n",
       "...          ...   ...    ...   ...        ...           ...       ...    ...   \n",
       "2017-03-07  6.17  6.18   6.16  6.12   88789.01         -0.01     -0.16  6.148   \n",
       "2017-03-06  6.12  6.18   6.17  6.10  107700.99          0.07      1.15  6.154   \n",
       "2017-03-03  6.11  6.13   6.10  6.05  167476.27         -0.03     -0.49  6.158   \n",
       "2017-03-02  6.18  6.21   6.13  6.12  130263.30         -0.05     -0.81  6.194   \n",
       "2017-03-01  6.21  6.21   6.18  6.17  132319.91         -0.01     -0.16  6.222   \n",
       "2017-02-28  6.20  6.22   6.19  6.14  132823.61          0.00      0.00  6.252   \n",
       "2017-02-27  6.29  6.33   6.19  6.17  176884.50         -0.09     -1.43  6.274   \n",
       "2017-02-24  6.27  6.29   6.28  6.23  114284.40          0.01      0.16  6.290   \n",
       "2017-02-23  6.33  6.33   6.27  6.24  152375.03         -0.06     -0.95  6.278   \n",
       "2017-02-22  6.31  6.39   6.33  6.29  202542.20          0.03      0.48  6.280   \n",
       "2017-02-21  6.26  6.30   6.30  6.25  183388.00          0.03      0.48  6.270   \n",
       "2017-02-20  6.20  6.27   6.27  6.19  181693.73          0.05      0.80  6.252   \n",
       "2017-02-17  6.27  6.32   6.22  6.21  191601.52         -0.06     -0.95  6.248   \n",
       "2017-02-16  6.24  6.30   6.28  6.19  240310.77          0.00      0.00  6.256   \n",
       "2017-02-15  6.22  6.50   6.28  6.16  442274.09          0.07      1.13  6.244   \n",
       "2017-02-14  6.25  6.27   6.21  6.18  176791.69         -0.04     -0.64  6.234   \n",
       "2017-02-13  6.23  6.25   6.25  6.20  140276.80         -0.01     -0.16  6.226   \n",
       "2017-02-10  6.21  6.26   6.26  6.21  168075.59          0.04      0.64  6.206   \n",
       "2017-02-09  6.21  6.23   6.22  6.19  131632.17         -0.01     -0.16  6.174   \n",
       "2017-02-08  6.15  6.24   6.23  6.15  136427.38          0.06      0.97  6.148   \n",
       "2017-02-07  6.14  6.19   6.17  6.12  107967.44          0.02      0.33  6.122   \n",
       "2017-02-06  6.10  6.15   6.15  6.07  106424.59          0.05      0.82  6.114   \n",
       "2017-02-03  6.09  6.12   6.10  6.07   63582.63          0.01      0.16  6.116   \n",
       "2017-01-26  6.08  6.11   6.09  6.05  119543.64         -0.01     -0.16  6.118   \n",
       "2017-01-25  6.12  6.15   6.10  6.09   95822.09         -0.03     -0.49  6.112   \n",
       "2017-01-24  6.17  6.19   6.13  6.13   75163.00         -0.03     -0.49  6.118   \n",
       "2017-01-23  6.10  6.19   6.16  6.09  110672.32          0.05      0.82  6.115   \n",
       "2017-01-20  6.06  6.13   6.11  6.02  103608.90          0.05      0.82  6.100   \n",
       "2017-01-19  6.09  6.11   6.06  5.99  112237.73         -0.07     -1.14  6.095   \n",
       "2017-01-18  6.16  6.18   6.13  6.10  108353.74         -0.04     -0.65  6.130   \n",
       "\n",
       "             ma10   ma20      v_ma5     v_ma10     v_ma20  \n",
       "date                                                       \n",
       "2019-07-19  3.054  3.100   73657.55  105869.71  140267.86  \n",
       "2019-07-18  3.063  3.106   84601.99  106993.41  149133.71  \n",
       "2019-07-17  3.074  3.113  123095.80  109450.36  156408.46  \n",
       "2019-07-16  3.081  3.115  123157.78  115757.67  161567.21  \n",
       "2019-07-15  3.092  3.117  126037.72  124907.26  167210.65  \n",
       "2019-07-12  3.106  3.115  138081.86  148553.59  168306.22  \n",
       "2019-07-11  3.117  3.116  129384.83  186458.85  178697.21  \n",
       "2019-07-10  3.120  3.115   95804.92  171442.57  176124.15  \n",
       "2019-07-09  3.129  3.116  108357.56  174784.47  182362.61  \n",
       "2019-07-08  3.136  3.115  123776.80  179452.28  187995.70  \n",
       "2019-07-05  3.146  3.109  159025.31  174666.01  185150.57  \n",
       "2019-07-04  3.148  3.098  243532.86  191274.02  187217.67  \n",
       "2019-07-03  3.151  3.090  247080.22  203366.56  187531.18  \n",
       "2019-07-02  3.149  3.081  241211.37  207376.75  187385.39  \n",
       "2019-07-01  3.141  3.072  235127.75  209514.04  185622.23  \n",
       "2019-06-28  3.124  3.062  190306.72  188058.85  176716.93  \n",
       "2019-06-27  3.114  3.055  139015.17  170935.57  161966.13  \n",
       "2019-06-26  3.110  3.050  159652.89  180805.73  162603.56  \n",
       "2019-06-25  3.103  3.046  173542.12  189940.75  166029.61  \n",
       "2019-06-24  3.094  3.042  183900.32  196539.12  168569.79  \n",
       "2019-06-21  3.072  3.034  185810.97  195635.12  173677.91  \n",
       "2019-06-20  3.047  3.027  202855.97  183161.31  172395.55  \n",
       "2019-06-19  3.028  3.023  201958.58  171695.81  171053.35  \n",
       "2019-06-18  3.012  3.023  206339.38  167394.03  172025.96  \n",
       "2019-06-17  3.002  3.023  209177.93  161730.43  174063.05  \n",
       "2019-06-14  3.000  3.027  205459.28  165375.01  183704.77  \n",
       "2019-06-13  2.996  3.036  163466.66  152996.69  180431.91  \n",
       "2019-06-12  2.990  3.045  141433.04  144401.39  192434.44  \n",
       "2019-06-11  2.989  3.055  128448.67  142118.48  202484.31  \n",
       "2019-06-10  2.990  3.063  114282.93  140600.46  203010.44  \n",
       "...           ...    ...        ...        ...        ...  \n",
       "2017-03-07  6.200  6.226  125309.90  140545.92  169896.55  \n",
       "2017-03-06  6.214  6.227  134116.82  150005.82  170855.47  \n",
       "2017-03-03  6.224  6.226  147953.52  157405.10  170791.65  \n",
       "2017-03-02  6.236  6.226  137315.14  159817.62  165596.97  \n",
       "2017-03-01  6.251  6.224  141737.49  170822.37  165060.98  \n",
       "2017-02-28  6.261  6.220  155781.95  201817.79  163236.09  \n",
       "2017-02-27  6.263  6.217  165894.83  206214.59  160353.06  \n",
       "2017-02-24  6.269  6.215  166856.67  202553.82  157042.45  \n",
       "2017-02-23  6.267  6.207  182320.10  207932.94  156508.68  \n",
       "2017-02-22  6.262  6.196  199907.24  205858.66  154501.81  \n",
       "2017-02-21  6.252  6.186  247853.62  199247.17  149792.39  \n",
       "2017-02-20  6.239  6.180  246534.36  191705.12  148024.20  \n",
       "2017-02-17  6.227  6.175  238250.97  184178.20  146153.67  \n",
       "2017-02-16  6.215  6.172  233545.79  171376.32  143480.27  \n",
       "2017-02-15  6.196  6.166  211810.07  159299.60  137428.36  \n",
       "2017-02-14  6.178  6.158  150640.73  124654.40  117105.31  \n",
       "2017-02-13  6.170  6.154  136875.88  114491.53  112842.00  \n",
       "2017-02-10  6.161  6.147  130105.43  111531.09  110731.63  \n",
       "2017-02-09  6.146  6.138  109206.84  105084.42  105952.97  \n",
       "2017-02-08  6.130  6.130  106789.14  103144.97  103618.50  \n",
       "2017-02-07  6.120  6.120   98668.08  100337.61  100337.61  \n",
       "2017-02-06  6.114  6.114   92107.19   99489.85   99489.85  \n",
       "2017-02-03  6.110  6.110   92956.74   98623.01   98623.01  \n",
       "2017-01-26  6.111  6.111  100961.99  103628.77  103628.77  \n",
       "2017-01-25  6.115  6.115   99500.81  100976.30  100976.30  \n",
       "2017-01-24  6.118  6.118  102007.14  102007.14  102007.14  \n",
       "2017-01-23  6.115  6.115  108718.17  108718.17  108718.17  \n",
       "2017-01-20  6.100  6.100  108066.79  108066.79  108066.79  \n",
       "2017-01-19  6.095  6.095  110295.74  110295.74  110295.74  \n",
       "2017-01-18  6.130  6.130  108353.74  108353.74  108353.74  \n",
       "\n",
       "[609 rows x 13 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import tushare as ts\n",
    "\n",
    "df = ts.get_hist_data('000875')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 将数据分别保存到不同的sheet页\n",
    "writer = pd.ExcelWriter('./dataFiles/000875.xlsx')\n",
    "df.to_excel(writer,'Sheet1')\n",
    "df.to_excel(writer,'Sheet2',columns=['open','high','low','close'])\n",
    "writer.save()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 保存整张数据表\n",
    "df.to_excel('./dataFiles/000875.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 保存指定的列\n",
    "df.to_excel('./dataFiles/000875.xlsx',sheet_name='sheet2',columns=['open','high','low','close'])"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
